
INSERT INTO MSTB_ITEM_MASTER_STATUS
(
    ID
  , REGION_CODE
  , PRICE_ITEM_NUMBER
  , SCANNING_ITEM_NUMBER
  , UNIFIED_ITEM_NUMBER
  , SUBSTITUTION_ITEM_NUMBER
  , STOCK_ITEM_NUMBER
  , PRIOR_LOCATION_NUMBER
  , PRIOR_LOCATION_POSITION
  , WAREHOUSE_CODE
  , PRIOR_TNA_STATUS
  , PRIOR_SALE_STATUS
  , UNTIL_DATE_TIME
  , POSTERIOR_LOCATION_NUMBER
  , POSTERIOR_LOCATION_POSITION
  , POSTERIOR_TNA_STATUS
  , POSTERIOR_SALE_STATUS
  , TRANSFER_STATUS
  , CREATED_TIMESTAMP
  , MODIFIED_TIMESTAMP
)
select 
    MSSQ_Item_Master_Status_ID.nextval                           as ID                                      
  , NULL                                                         as REGION_CODE                             
  , NULL                                                         as PRICE_ITEM_NUMBER                       
  , NULL                                                         as SCANNING_ITEM_NUMBER                    
  , NULL                                                         as UNIFIED_ITEM_NUMBER                     
  , NULL                                                         as SUBSTITUTION_ITEM_NUMBER                
  , 12345                                                        as STOCK_ITEM_NUMBER                       
  , NULL                                                         as PRIOR_LOCATION_NUMBER                   
  , NULL                                                         as PRIOR_LOCATION_POSITION                 
  , 'UTC1'                                                       as WAREHOUSE_CODE                          
  , 3                                                            as PRIOR_TNA_STATUS                        
  , '3'                                                          as PRIOR_SALE_STATUS                       
  , to_date('2011-09-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS')      as UNTIL_DATE_TIME                         
  , NULL                                                         as POSTERIOR_LOCATION_NUMBER               
  , NULL                                                         as POSTERIOR_LOCATION_POSITION             
  , 3                                                            as POSTERIOR_TNA_STATUS                    
  , '0'                                                          as POSTERIOR_SALE_STATUS                   
  , NULL                                                         as TRANSFER_STATUS                         
  , to_date('2011-08-29 20:50:46', 'YYYY-MM-DD HH24:MI:SS')      as CREATED_TIMESTAMP                       
  , to_date('2011-08-29 20:50:46', 'YYYY-MM-DD HH24:MI:SS')      as MODIFIED_TIMESTAMP                      
from dual;